package SnailCatMallWebAppliction.mapper;

import SnailCatMallWebAppliction.domain.Product;import org.apache.ibatis.annotations.Param;import java.util.List;

public interface ProductMapper {
    int deleteByPrimaryKey(Integer productId);

    int insert(Product record);

    int insertSelective(Product record);

    Product selectByPrimaryKey(Integer productId);

    int updateByPrimaryKeySelective(Product record);

    int updateByPrimaryKey(Product record);

    int deleteByProductMd5(@Param("productMd5") String productMd5);

    List<Product> selectAllByProductName(@Param("productName") String productName);

    List<Product> selectByProductNumber(@Param("productNumber") String productNumber);

    Product selectFirstByProductNumber(@Param("productNumber") String productNumber);

    int deleteByProductNumber(@Param("productNumber") String productNumber);

    List<Product> selectByAll();

    int updateByProductMd5(@Param("updated") Product updated, @Param("productMd5") String productMd5);

    List<Product> selectpaging(@Param("offset") Integer offset, @Param("limit") Integer limit);

    List<Product> selectpagingIF(@Param("ifmd5") String ifmd5, @Param("offset") Integer offset, @Param("limit") Integer limit);

    List<Product> selectAllByProductMd5AndProductMd5(@Param("productMd5")String productMd5);


}